package com.zhidisoft.admin.mapper;

import java.math.BigInteger;
import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.zhidisoft.admin.entity.Article;

public interface IBlogMapper {

	/**
	 * 分页查询
	 * @param startIndex
	 * @param pageSize
	 * @return
	 */
	@Select("select * from article limit #{startIndex},#{pageSize}")
	public List<Article> pageList(@Param("startIndex") Integer startIndex,@Param("pageSize") Integer pageSize);
	
	/**
	 * 获取总条数
	 * @return
	 */
	@Select("SELECT count(id) FROM article")
	public BigInteger totalCount();
}
